# -*- coding:utf-8 -*-
# @Time : 2020/9/21 20:52
# @Author : liruiyang
# @File : UserInfoModel
# @Software: PyCharm
# @Description: 这是一个python程序
# here put the import lib

from . import db


class UserInfo(db.Model):
    __tablename__ = 'user_info'

    userID = db.Column(db.String(30, 'utf8_general_ci'), primary_key=True, info='用户主键')
    userName = db.Column(db.String(255), info='用户名')
    mail = db.Column(db.String(255, 'utf8_general_ci'), nullable=False, info='邮箱')
    password = db.Column(db.String(255, 'utf8_general_ci'), nullable=False, info='密码')
    otherInfo = db.Column(db.String(400), info='其他信息（json格式数据）')
    userType = db.Column(db.Integer, info='用户类型')
    createTime = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='创建时间')
